UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BpoGhLr4PccM4ao+wdKGZ7ummaH3jFWMeyHd3AkOLAk='
WHERE
key_id = 'c6e6283fac7743fc13fd0da822e1f3911fcc9ddf3476f27f64f61ef103738172'
AND (
token = 'BpoGhLr4PccM4ao+wdKGZ7ummaH3jFWMeyHd3AkOLAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)