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