UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NzYL0WgM9CI88UOyq2jKadrYaws2kif96lw6LlcgBfQ='
WHERE
key_id = '0f4859a6c0c8eba320429e836859142fc49c3d35842e7c27c0947dc49c6fad41'
AND (
token = 'NzYL0WgM9CI88UOyq2jKadrYaws2kif96lw6LlcgBfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)