UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P547yXH2SLWLeI63jtz/koDA7swh42METk2B4HifjCI='
WHERE
key_id = '5141b151aeb7b1d5a304c33bd04d6345e17647230ff442063a203416cd2c7f8a'
AND (
token = 'P547yXH2SLWLeI63jtz/koDA7swh42METk2B4HifjCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)