UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dY1GVqWGnM3ahKAZI3V/MF8uwDtJ0Xk5aOYY1zCxjKM='
WHERE
key_id = 'a4950ce2880fc5fe21db0d3366a0b2f5c1c4fc76a4dc3ee130d63aa48a651d58'
AND (
token = 'dY1GVqWGnM3ahKAZI3V/MF8uwDtJ0Xk5aOYY1zCxjKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)