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