UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7WSLMSBI9L2GYH4bFi1FB1qzPQdlCO77kP7VVVcihic='
WHERE
key_id = 'ad0e974322e3be4a7a0eb95540c58d52265d62800298c5575c1bdbb2ff3dcfe4'
AND (
token = '7WSLMSBI9L2GYH4bFi1FB1qzPQdlCO77kP7VVVcihic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)