UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NGdg0VCr2TttWcYLIYCyCZjcfmB53ck3eSzbLYjikx4='
WHERE
key_id = 'eff9885337491bd72a1e2b236e74d2b0a7fa566899fdd17735bcedcf2665dd59'
AND (
token = 'NGdg0VCr2TttWcYLIYCyCZjcfmB53ck3eSzbLYjikx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)