UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C17kPyIVV52nZmKU/PkcmKGp0657ZXp6prY3hKKIdio='
WHERE
key_id = 'f48eca6a7bb96c648abd8f85d6176c6961e221a9b7515731e0b948b5ba8a5410'
AND (
token = 'C17kPyIVV52nZmKU/PkcmKGp0657ZXp6prY3hKKIdio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)