UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6LMExxI++E/gvuPjd20sitgmeCtw4H58amhYx/TtKU='
WHERE
key_id = '3c7cc88887a21f7cd4ae06436c8d700cfb7ac9c252d7e13059179a68716a7df1'
AND (
token = 'C6LMExxI++E/gvuPjd20sitgmeCtw4H58amhYx/TtKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)