UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bFQz7bgD63/iXiRPu9CKUSHDgta6EJ1zQmDKLXW0iD0='
WHERE
key_id = 'ec8d71ba364f5d7d12ec23fe29a46bf02bdad58d069fbdd2af6bee2094401b49'
AND (
token = 'bFQz7bgD63/iXiRPu9CKUSHDgta6EJ1zQmDKLXW0iD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)