UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcLAEKR3qZVH6Eo7qZ4TDrUK8v2NJZl4i6rV0PjyXcw='
WHERE
key_id = '77b3a8c71bcbba182edff04fbac904a4e12d1706250e6fd17064f7a609b7666b'
AND (
token = 'XcLAEKR3qZVH6Eo7qZ4TDrUK8v2NJZl4i6rV0PjyXcw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)