UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDsHkcZo0I+rYmm6YpxHALK4Cy2BGbIQvcMWTO0d7iU='
WHERE
key_id = '40b7bc0cd752834fc99f1d41beceddbd3a0136d70fd8d00af2b08dfb3bad3025'
AND (
token = 'ZDsHkcZo0I+rYmm6YpxHALK4Cy2BGbIQvcMWTO0d7iU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)