UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpw2l1dNbRr+PRAuMumkGxmg3vgioFqQvDqCso5UOX4='
WHERE
key_id = '12e7ab6dd68a769e9aa87a7679cb6c042399eb0f07d1a24b748a8fc095a1e7e1'
AND (
token = 'zpw2l1dNbRr+PRAuMumkGxmg3vgioFqQvDqCso5UOX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)