UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJvjeO9+rbrWaxTwia1UEINl+VE399rEVh++RIrlGl4='
WHERE
key_id = 'dcd4a3d7c138e693de8b57f7a75cdabdc90c8685a54ed223e8ee5296e04e160e'
AND (
token = 'zJvjeO9+rbrWaxTwia1UEINl+VE399rEVh++RIrlGl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)