UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XUgL4uxGL1RHjvAZg5TjFQAm1CIftoYli4atoFW/NC0='
WHERE
key_id = 'cd099138cde15ca3f98d315e01f7dad5e0c08de250715ed7bcb0bf6605d8b3ec'
AND (
token = 'XUgL4uxGL1RHjvAZg5TjFQAm1CIftoYli4atoFW/NC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)