UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9WWlhyZ4jcyDQuiOgh7XZO3dAeIbYSuzUsc7bQkITyA='
WHERE
key_id = '540afae10beb3b5473b2805fabe16dc1aefd74e1231bd7d5fec66b6621dea7d6'
AND (
token = '9WWlhyZ4jcyDQuiOgh7XZO3dAeIbYSuzUsc7bQkITyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)