UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zappuaAsmiL9dDar5kGHSGK2Zh6qZZJbDFpwOtLXZ4E='
WHERE
key_id = '3580388f1eb717658afe11dee208303af580c6aee01b07cc18a07f1b6937a17a'
AND (
token = 'zappuaAsmiL9dDar5kGHSGK2Zh6qZZJbDFpwOtLXZ4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)