UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JnAP1cRSuVkDw3h1opFTNSz5m/2mx5NPWu8zNTxPf9M='
WHERE
key_id = '1ea152a139b8f5a74b0accc92382d32d5e808b02f405535e47038a2091724663'
AND (
token = 'JnAP1cRSuVkDw3h1opFTNSz5m/2mx5NPWu8zNTxPf9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)