UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fzdWmd5ZJ5xDcxyfNpSfC/wUtf5o4HcwRxLFa80tTF4='
WHERE
key_id = 'fb4b3bef87f065973d9cc2d77b0e2fdfec8c685f9f1a2421e4068a5ec0291fb2'
AND (
token = 'fzdWmd5ZJ5xDcxyfNpSfC/wUtf5o4HcwRxLFa80tTF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)