UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CVkVOvW09LqsgM4RqoCVll3Ev1hRdsAV4pGiVj3lL78='
WHERE
key_id = 'bad36fb29005482e531ea09f8e16405760237d7bd34549af8f35f9d57f315af2'
AND (
token = 'CVkVOvW09LqsgM4RqoCVll3Ev1hRdsAV4pGiVj3lL78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)