UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgcR6d9o9zD2kGWd9CrHgf25jvpN/Jziawi15EfNZhA='
WHERE
key_id = 'e889c419d1e0f23610784548ecbcae449d305287e403c2d99a20353d2c099fd3'
AND (
token = 'sgcR6d9o9zD2kGWd9CrHgf25jvpN/Jziawi15EfNZhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)