UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6tgCN0VQaNYkQNX/Zt5bf6agNImWSFqgSl7nwCfnqU='
WHERE
key_id = '1d9f370d0220226377b39656ee647345be2caec9db03f497835c2cb8a32289e5'
AND (
token = 'z6tgCN0VQaNYkQNX/Zt5bf6agNImWSFqgSl7nwCfnqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)