UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JRmc24GNOVL/JLzI8q4JPafe99RDWO8YDV2jlyKvefU='
WHERE
key_id = 'c16c3499010ef9977822e4f278a5d9aa881860cef00864ee6ea34f0f41a86489'
AND (
token = 'JRmc24GNOVL/JLzI8q4JPafe99RDWO8YDV2jlyKvefU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)