UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CI2djOZlJxclRHlaWc0mVICZkzYjC9No7xy3bLwPvAk='
WHERE
key_id = '18c1d1641c3a339c07dd1f35d5fff0acea63ab3cd3885c93cb91e2871d9f7473'
AND (
token = 'CI2djOZlJxclRHlaWc0mVICZkzYjC9No7xy3bLwPvAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)