UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'poc7tb5TKc5+uxA5pxYXT8Ymk2ErzUGMto8VP0olwi8='
WHERE
key_id = 'b78a37d2f4d3880ee1989b18f03f30c4817fae26d4016c7ce6b0b2ea2629c174'
AND (
token = 'poc7tb5TKc5+uxA5pxYXT8Ymk2ErzUGMto8VP0olwi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)