UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TH2QouxMvIrOUrXXEqQ98o8akfhIK3gAvYqTZKrKAo='
WHERE
key_id = '28e6e8a29e323219356ff194ea2dc1a95cfc3748aade433e5e694beac3891836'
AND (
token = '6TH2QouxMvIrOUrXXEqQ98o8akfhIK3gAvYqTZKrKAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)