UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tAmH7iOmSG8QacnPLha4BKIjNvshg7e+s/lr55b4nBk='
WHERE
key_id = '9a6d3308083a6a0f9cbde70b94806695fa521746afd6cbc0c37fbaeb8302bf53'
AND (
token = 'tAmH7iOmSG8QacnPLha4BKIjNvshg7e+s/lr55b4nBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)